Time Output Registry entry
Specify the format in which times will display in a client when retrieved from a database.
Usage
This Registry entry can be assigned to users, groups and system-wide:
Key | User | Group | Key | System |
---|---|---|---|---|
Key 1 | User
|
Group
|
Key 1 | System
|
Key 2 | user | group | Key 2 | Setting
|
Key 3 | Setting
|
Key 3 | Format
|
|
Key 4 | Format
|
Key 4 | Time Output
|
|
Key 5 | Time Output
|
|||
Value | format | Value | format |
In pipe-delimited format:
User
|
user | Setting
|
Format
|
Time Output
|
format |
Group
|
group | Setting
|
Format
|
Time Output
|
format |
System
|
Setting
|
Format
|
Time Output
|
format |
where:
format | is a series of special characters: | |
Character |
Description |
|
HH
|
Hour - two digit 24 hour format with values ranging from 00 - 23 |
|
H
|
Hour - 24 hour format with values ranging from 0 - 23 |
|
hh
|
Hour - two digit 12 hour format with values ranging from 01 - 12 |
|
h
|
Hour - 12 hour format with values ranging from 1 - 12 |
|
m
|
Minute - values ranging from 0 - 59 |
|
mm
|
Minute - two digit values ranging from 00 - 59 |
|
M
|
Minute - displayed with a decimal component that represents the seconds as a fraction of a minute, e.g. 4 minutes, 15 seconds, displays as 4.25 |
|
MM
|
Minute - as for M , except that the minutes component is a two digit value, eg. 04.25 |
|
s
|
Second - values ranging from 0 - 59 |
|
ss
|
Second - two digit values ranging from 00 - 59 |
|
t
|
Displays am or pm as appropriate. |
Note: The format characters can be combined to create the desired date string, separated by any other character(s).
Examples
This setting will generate a time format of 18:43
:
Field | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Format
|
Key 4 | Time Output
|
Value | HH:mm
|
This setting will generate a time format of 6:43pm
:
Field | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Format
|
Key 4 | Time Output
|
Value | h:mmt
|